﻿EXEC	[dbo].[spMSX_create_job]	@is_local_job		= 1,
									@job_name			= 'DBA: Monitoring Performance Hourly Rollup and Prune',
									@job_description	= 'Monitoring Performance Hourly Rollup and Prune',
									@job_category		= 'DBA: Monitoring',
									@schedule_name		= 'TL ##:33 Hourly - Local',
									@step1_name			= 'DBA: Monitoring Performance Hourly Rollup',
									@step1_subsystem	= 'TSQL',
									@step1_command		= 'EXEC [dbo].[spMonitor_PerfmonHourlySummaries]',
									@step2_name			= 'DBA: Monitoring Performance Pruning',
									@step2_subsystem	= 'TSQL',
									@step2_command		= 'EXEC [dbo].[spMonitor_PrunePerfmon]'
